package com.example.demo.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.cache.annotation.Cacheable;

import java.util.List;
import java.util.Map;

@Mapper
public interface JobDao {

    @Cacheable(cacheNames="job")
    @Select(" select str5 job, avg(str7) as avgscore from job_score group by str5 ")
    List<Map> getjobavg();
}
